CREATE TABLE [dbo].[USOS]
(
[ID] [numeric] (10, 0) NOT NULL,
[MOTOR] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SERIE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ID_MODELO] [numeric] (10, 0) NOT NULL,
[ID_VERSION] [numeric] (10, 0) NOT NULL,
[ANIO_INICIAL] [numeric] (4, 0) NOT NULL,
[ANIO_FINAL] [numeric] (4, 0) NOT NULL,
[ID_ORIGINAL_ADICIONAL] [numeric] (10, 0) NOT NULL,
[COMENTARIO] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[USOS] ADD CONSTRAINT [PK_USOS] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[USOS] ADD CONSTRAINT [FK_USOS_MODELOS] FOREIGN KEY ([ID_MODELO]) REFERENCES [dbo].[MODELOS] ([ID])
GO
ALTER TABLE [dbo].[USOS] ADD CONSTRAINT [FK_USOS_VERSIONES] FOREIGN KEY ([ID_VERSION]) REFERENCES [dbo].[VERSIONES] ([ID])
GO
